-
Re: Need some assistance on using "IF(AND) logic. I'm trying to render a "Red" "Yellow" or "Green".
You don't need the parenthesis around the 1 and it might be better to use NETDAYS() to compare the current date to the end date. Try this: =IF(OR([% Complete]@row=1, NETDAYS(TODAY(), [End Date]@row)&…1 ·